# -*- coding: utf-8 -*-
"""
Created on Sat Jul  2 15:48:50 2016

@author: Aeen
"""
import pandas as pd
import xlrd

df = pd.read_excel(r'f:\质检表.xls', sheetname='Sheet2', skiprows=1, index_col=0)
table = xlrd.book.open_workbook_xls(r'f:\质检表.xls').sheets()[0].row_values(0)
df.columns = table
print(df.head())
